500 |
Is it possible to prevent closing the control's filter bar, so it is always shown
With Excombobox1 .BeginUpdate() .Columns.Add("Item").DisplayFilterButton = True With .Columns.Add("Pos") .AllowSizing = False .AllowSort = False .Width = 32 .FormatColumn = "1 apos ``" .Position = 0 End With With .Items .AddItem("Item A") .AddItem("Item B") .AddItem("Item C") End With .FilterBarCaption = "len(value) = 0 ? `<fgcolor=808080>no filter` : value" .FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible With .Columns.Item(0) .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "Item B" End With .ApplyFilter() .EndUpdate() End With |
499 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)
Dim h With Excombobox1 .BeginUpdate() With .VisualAppearance .Add(3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _ "XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _ "gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _ "INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=") .Add(1,"CP:3 -2 -2 2 2") .Add(4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _ "eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _ "FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _ "JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=") .Add(2,"CP:4 -2 -2 2 2") End With .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot .HasButtons = exontrol.EXCOMBOBOXLib.ExpandButtonEnum.exCustom .set_HasButtonsCustom(False,16777216) .set_HasButtonsCustom(True,33554432) .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With .EndUpdate() End With |
498 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)
Dim h With Excombobox1 .BeginUpdate() With .VisualAppearance .Add(1,"XP:TREEVIEW 2 1") .Add(2,"XP:TREEVIEW 2 2") End With .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphOpen,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphClose,&H2000000) .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With .EndUpdate() End With |
497 |
How can I find if the control is running in DPI mode
With Excombobox1 Debug.Print( .FormatABC("dpi = 1 ? `normal/stretch mode` : `dpi mode`") ) End With |
496 |
How can I change the visual appearance of the +/- buttons (method 1)
Dim h With Excombobox1 .BeginUpdate() With .VisualAppearance .Add(1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _ "XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _ "gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _ "INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=") .Add(2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _ "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _ "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _ "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _ "eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _ "FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _ "JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=") End With .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphOpen,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exTreeGlyphClose,&H2000000) .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With .EndUpdate() End With |
495 |
Is there a way to change the dropdown button arrow to something else ( ebn, sample 3 )
Dim h With Excombobox1 .BeginUpdate() .VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" & _ "IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" & _ "aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" & _ "eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" & _ "BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" & _ "GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhuZwJkYcoagiZ5+HQFRngmZh6h6Z5JnYfodCaCgGBcOpfBQBCAgA==") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonUp,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonDown,&H1f0f0f0) .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .Columns.Add("P1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) .set_SelectItem(h,True) End With .EndUpdate() End With |
494 |
Is there a way to change the dropdown button arrow to something else ( ebn, sample 2 )
Dim h With Excombobox1 .BeginUpdate() .VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABKgCg6AADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" & _ "IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" & _ "aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" & _ "eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/EeH5wiITwUkWMRsF4PYgEeaZ3gGYBoCWeICk6V5wnMf4FDCAAfAiYQgg4" & _ "AYAmAWC7gIIYnm2fR/mEUYAF4GIFFEVBYgUYR4BCdoGmKSB6A+CAhDGBBfBiT4IlSdQ9A8WIWCeBJihgZgcg+YJoEIFYMiMSJWAaDZjhiGgogCIooG4QYMAIOQSDUPgi" & _ "lONhIg6JI4GIK4LiQKJGDOFJgGMbJbDcDg5hYR4OCWCJyEyAQiCGChDheZBoDIYg3AMIJEVYQ4AnoZQ4mYeQmDsCJGmGNBwDQTQDEaAQcCYCZKGOHRDHgVgVh4J4phoD" & _ "ISAaEYkGsNhNhMahVhyaJIFSDiuAIBIBCCaJ5mYe4VGGOhyHaBRInIPIRH2D5qkaIopCEOhCieBxjnqKoNgSapaj6OIsE+apOiWJBnkqYo6isKpqiGdIwCwKpWiaJIOl" & _ "sHo8jIa4JFaTIomwOZuBeMgrmifpKgGbR6lAI4lEaM4ymYKIKCKEpfjqbI6kSHgnEmc5GnIOpfBQBCAg=") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonUp,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonDown,&H1808080) .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .Columns.Add("P1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) .set_SelectItem(h,True) End With .EndUpdate() End With |
493 |
Is there a way to change the dropdown button arrow to something else ( ebn, sample 1 )
Dim h With Excombobox1 .BeginUpdate() .VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABFACg6AADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" & _ "IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" & _ "aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" & _ "eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5dlqIh/k8SAFnofxgDgFZ8gGH5ShYCgmiCQgeA6AghAgr5/EyWBUhC" & _ "BZPngZIvgaSpoHYEYBCEOAMnWCJGgiFgZgmYoIDiBw1iKSB+C4fQHhiRJjgyYoIlYJwXmOA56DqC5iAONIhg+S45AYNoQmGExqEYIJkgicZ2gsDRhG4ToSAgMZqFIOol" & _ "EiHJzhWSIJGYUAZiWSBsi+EofEkGhiDaCIphSPIZmIcp2GoI4mkmDhGD4JwJgIPQkmcQwqHaCZKgmZI0h6ZwonCFIfmYKIch6IJMhoFh9ggXxIgydQZmjTR5iORhKEaB" & _ "4PGAOgUkmD5KBiHItiaSwKHaE4CPuBoMVieJMmMH4qgofoIDsRx6jSZorksapGGUIoqiidJHi2RYKmSHIumEchAh2L5rFeWhUDqAxbBQSIxkeCwkjGMpOAsNpBH0Do3k" & _ "UASAg") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonUp,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonDown,&H1808080) .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .Columns.Add("P1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) .set_SelectItem(h,True) End With .EndUpdate() End With |
492 |
Is there a way to change the dropdown button arrow to something else ( theme, ebn )
Dim h With Excombobox1 .BeginUpdate() With .VisualAppearance .Add(1,"XP:SCROLLBAR 1 6") .Add(2,"XP:SCROLLBAR 1 7") End With .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonUp,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonDown,&H2000000) .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .Columns.Add("P1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) .set_SelectItem(h,True) End With .EndUpdate() End With |
491 |
Is there a way to change the dropdown button arrow to something else ( no visual theme )
Dim h With Excombobox1 .BeginUpdate() .UseVisualTheme = exontrol.EXCOMBOBOXLib.UIVisualThemeEnum.exBorderVisualTheme Or exontrol.EXCOMBOBOXLib.UIVisualThemeEnum.exCheckBoxVisualTheme Or exontrol.EXCOMBOBOXLib.UIVisualThemeEnum.exCalendarVisualTheme Or exontrol.EXCOMBOBOXLib.UIVisualThemeEnum.exFilterBarVisualTheme Or exontrol.EXCOMBOBOXLib.UIVisualThemeEnum.exHeaderVisualTheme .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .Columns.Add("P1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) .set_SelectItem(h,True) End With .EndUpdate() End With |
490 |
Is there a way to change the dropdown button arrow to something else ( solid color )
Dim h With Excombobox1 .BeginUpdate() .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonDown,Color.FromArgb(190,190,190)) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonUp,Color.FromArgb(128,128,128)) .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .Columns.Add("P1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) .set_SelectItem(h,True) End With .EndUpdate() End With |
489 |
How can I find if there is any filter applied to the control
' FilterChange event - Occurs when filter was changed. Private Sub Excombobox1_FilterChange(ByVal sender As System.Object) Handles Excombobox1.FilterChange With Excombobox1 Debug.Print( "If negative, the filter is present, else not" ) Debug.Print( .Items.VisibleItemCount ) End With End Sub Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .TreeColumnIndex = -1 .FilterInclude = exontrol.EXCOMBOBOXLib.FilterIncludeEnum.exMatchingItemsOnly With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "C1" End With With .Items h = .AddItem("R1") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") .set_ExpandItem(h,True) h = .AddItem("R2") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") End With .ApplyFilter() .EndUpdate() End With |
488 |
How can I prevent showing the lines for the hierarchy while using the exMatchingItemsOnly option
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .TreeColumnIndex = -1 .FilterInclude = exontrol.EXCOMBOBOXLib.FilterIncludeEnum.exMatchingItemsOnly With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "C1|C2" End With With .Items h = .AddItem("R1") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") .set_ExpandItem(h,True) h = .AddItem("R2") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") End With .ApplyFilter() .EndUpdate() End With |
487 |
Is there any method to get only the matched items and not the items with his parent
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .FilterInclude = exontrol.EXCOMBOBOXLib.FilterIncludeEnum.exMatchingItemsOnly With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "C1|C2" End With With .Items h = .AddItem("R1") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") .set_ExpandItem(h,True) h = .AddItem("R2") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") End With .ApplyFilter() .EndUpdate() End With |
486 |
How do I get sorted the column as string, numeric, date, date and time. Also how can it be applied to drop down filter panel
Dim h With Excombobox1 .BeginUpdate() With .Columns.Add("Date") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortDate .DisplayFilterButton = True .DisplayFilterPattern = False .DisplayFilterDate = True .FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exShowFocusItem Or exontrol.EXCOMBOBOXLib.FilterListEnum.exShowCheckBox Or exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsDesc End With With .Columns.Add("DateTime") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortDateTime .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exShowFocusItem Or exontrol.EXCOMBOBOXLib.FilterListEnum.exShowCheckBox Or exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsDesc End With With .Columns.Add("Time") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortTime .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exShowFocusItem Or exontrol.EXCOMBOBOXLib.FilterListEnum.exShowCheckBox Or exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsDesc .FormatColumn = "time(value)" End With With .Columns.Add("Numeric") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric .DisplayFilterButton = True .FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exShowFocusItem Or exontrol.EXCOMBOBOXLib.FilterListEnum.exShowCheckBox Or exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsDesc End With With .Columns.Add("String") .DisplayFilterButton = True .FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exShowFocusItem Or exontrol.EXCOMBOBOXLib.FilterListEnum.exShowCheckBox Or exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsDesc End With With .Items h = .AddItem(#1/27/2010#) .set_CellCaption(h,1,#1/27/2010 10:00:00 AM#) .set_CellCaption(h,2,.get_CellCaption(h,1)) .set_CellCaption(h,3,1) .set_CellCaption(h,4,.get_CellCaption(h,3)) h = .AddItem(#1/27/2011#) .set_CellCaption(h,1,#1/27/2011 9:00:00 AM#) .set_CellCaption(h,2,.get_CellCaption(h,1)) .set_CellCaption(h,3,11) .set_CellCaption(h,4,.get_CellCaption(h,3)) h = .AddItem(#11/2/2010#) .set_CellCaption(h,1,#11/2/2010 9:00:00 AM#) .set_CellCaption(h,2,.get_CellCaption(h,1)) .set_CellCaption(h,3,2) .set_CellCaption(h,4,.get_CellCaption(h,3)) End With .Columns.Item("DateTime").DisplayFilterDate = False .EndUpdate() End With |
485 |
How can I display a different column, on the control's label (method 2)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .SingleEdit = True .LabelColumnIndex = 1 .DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines .Columns.Add("Column 1").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .Columns.Add("Column 2").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items .set_CellCaption(.AddItem("Item 1 on <b>Column 1"),1,"Item 1 on <b>Column 2") .set_CellCaption(.AddItem("Item 2 on <b>Column 1"),1,"Item 2 on <b>Column 2") .set_CellCaption(.AddItem("Item 3 on <b>Column 1"),1,"Item 3 on <b>Column 2") .set_SelectItem(.FirstVisibleItem,True) End With .EndUpdate() End With |
484 |
How can I display a different column, on the control's label (method 1)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .SingleEdit = True .SearchColumnIndex = 1 .DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines .Columns.Add("Column 1").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .Columns.Add("Column 2").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items .set_CellCaption(.AddItem("Item 1 on <b>Column 1"),1,"Item 1 on <b>Column 2") .set_CellCaption(.AddItem("Item 2 on <b>Column 1"),1,"Item 2 on <b>Column 2") .set_CellCaption(.AddItem("Item 3 on <b>Column 1"),1,"Item 3 on <b>Column 2") .set_SelectItem(.FirstVisibleItem,True) End With .EndUpdate() End With |
483 |
How do I sort the index column as numeric
' InsertItem event - Occurs after a new item has been inserted to Items collection. Private Sub Excombobox1_InsertItem(ByVal sender As System.Object,ByVal Item As Integer) Handles Excombobox1.InsertItem With Excombobox1 With .Items .set_CellData(Item,1,.get_ItemToIndex(Item)) End With End With End Sub With Excombobox1 .BeginUpdate() .DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exAllLines .ColumnAutoResize = True .ShowFocusRect = False .SingleEdit = True With .Columns.Add("Next") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellPaddingLeft,4) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingLeft,4) End With With .Columns.Add("Index") .AllowSizing = False .Width = 48 .FormatColumn = "(((0 := (1 index ``)) mod 3) case ( default: ``; 0 : `<r><fgcolor=B0B0B0>`; 1: ``; 2 : `<c><fgcolor=808080>` )) + str(=:0)" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortUserData .Position = 0 End With With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .AddItem("Item 5") .AddItem("Item 6") .AddItem("Item 7") .AddItem("Item 8") .AddItem("Item 9") .AddItem("Item 10") End With .EndUpdate() End With |
482 |
How can I put icons/images into buttons
With Excombobox1 .BeginUpdate() .SingleEdit = True .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .Columns.Add("") With .Columns.Add("C+B") .AllowSizing = False .Width = 48 .FormatColumn = "` <img>` + ( 1 + (1 index ``) mod 3 ) + `</img> `" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellButtonAutoWidth,True) .Position = 0 End With .DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines .DefaultItemHeight = 20 With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .AddItem("Item 5") .AddItem("Item 6") .AddItem("Item 7") .AddItem("Item 8") End With .EndUpdate() End With |
481 |
Is it possible to have a CheckBox and Button TOGETHER on all cells in a column
' CellButtonClick event - Fired after the user clicks on the cell of button type. Private Sub Excombobox1_CellButtonClick(ByVal sender As System.Object,ByVal Item As exontrol.EXCOMBOBOXLib.HCELL) Handles Excombobox1.CellButtonClick With Excombobox1 Debug.Print( "CellButtonClick" ) Debug.Print( Item ) Debug.Print( .get_Key() ) End With End Sub ' CellStateChanged event - Fired after cell's state has been changed. Private Sub Excombobox1_CellStateChanged(ByVal sender As System.Object,ByVal Item As exontrol.EXCOMBOBOXLib.HCELL) Handles Excombobox1.CellStateChanged With Excombobox1 Debug.Print( "CellStateChanged" ) Debug.Print( Item ) Debug.Print( .get_Key() ) End With End Sub With Excombobox1 .BeginUpdate() .SingleEdit = True With .Columns.Add("") .AllowSizing = False .Width = 32 .FormatColumn = "1 index ``" End With With .Columns.Add("Def") .AllowSizing = False .Width = 48 .FormatColumn = "` `" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellButtonAutoWidth,True) End With .Columns.Add("") With .Items .AddItem("") .AddItem("") .AddItem("") .AddItem("") .AddItem("") .AddItem("") .AddItem("") .AddItem("") End With .EndUpdate() End With |
480 |
How can I show only the matching items, while user types in the drop down control
' EditChange event - Fired when the user has taken an action that may have altered text in an edit control. Private Sub Excombobox1_EditChange(ByVal sender As System.Object,ByVal ColIndex As Integer) Handles Excombobox1.EditChange Dim sLabel With Excombobox1 sLabel = .get_EditText(ColIndex) Debug.Print( "Select the item that maches exactly the typing label: " ) Debug.Print( sLabel ) With .Items .set_SelectItem(.FocusItem,False) .set_SelectItem(.get_FindItem(sLabel,ColIndex),True) End With End With End Sub With Excombobox1 .BeginUpdate() .SingleEdit = True .AutoComplete = False .AutoSelect = False .AutoSearch = False .AutoDropDown = True .IntegralHeight = True .HeaderVisible = False .Columns.Add("Friends") With .Items .AddItem("Fred") .AddItem("Tina") .AddItem("Tom") End With .EndUpdate() End With |
479 |
How do I unselect/deselect the item (Simple style)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.Simple .Columns.Add("Def") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 3") End With .SearchColumnIndex = 0 .Value = "Item 2" With .Items .set_SelectItem(.FocusItem,False) End With .EndUpdate() End With |
478 |
How do I unselect/deselect the item (DropDownList style)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDown .Columns.Add("Def") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 3") End With .SearchColumnIndex = 0 .Value = "Item 2" With .Items .set_SelectItem(.FocusItem,False) End With .EndUpdate() End With |
477 |
How do I unselect/deselect the item (DropDown style)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDown .Columns.Add("Def") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 3") End With .SearchColumnIndex = 0 .Value = "Item 2" With .Items .set_SelectItem(.FocusItem,False) End With .EndUpdate() End With |
476 |
Setting the ForeColor to red and then setting Enabled property on False the ForeColor returns back to original color of black/gray. What can be done (Style is Simple)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.Simple .ColumnAutoResize = True With .Columns .Add("C1") .Add("C2") End With With .Items .set_CellCaption(.AddItem("item a"),1,"item b") .set_CellCaption(.AddItem("item c"),1,"item d") End With .Value = "item a" .ForeColor = Color.FromArgb(128,128,188) .BackColor = Color.FromArgb(240,240,240) .HeaderForeColor = Color.FromArgb(128,128,128) .SelBackColor = Color.FromArgb(128,128,128) .BackColorEdit = Color.FromArgb(0,0,0) .ForeColorEdit = Color.FromArgb(255,255,255) .Enabled = False .EndUpdate() End With |
475 |
Setting the ForeColor to red and then setting Enabled property on False the ForeColor returns back to original color of black/gray. What can be done (Style is DropDownList)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .ColumnAutoResize = True With .Columns .Add("C1") .Add("C2") End With With .Items .set_CellCaption(.AddItem("item a"),1,"item b") .set_CellCaption(.AddItem("item c"),1,"item d") End With .Value = "item a" .BackColorEdit = Color.FromArgb(0,0,0) .ForeColor = Color.FromArgb(255,255,255) .Enabled = False .EndUpdate() End With |
474 |
Setting the ForeColor to red and then setting Enabled property on False the ForeColor returns back to original color of black/gray. What can be done (Style is DropDown)
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDown .ColumnAutoResize = True With .Columns .Add("C1") .Add("C2") End With With .Items .set_CellCaption(.AddItem("item a"),1,"item b") .set_CellCaption(.AddItem("item c"),1,"item d") End With .Value = "item a" .ForeColorEdit = Color.FromArgb(255,255,255) .BackColorEdit = Color.FromArgb(0,0,0) .Enabled = False .EndUpdate() End With |
473 |
How would you clear the displayed selection for style DropDownList. So if a user selects or searches a value in a style DropDownList, I want to know if I can reset the control back to an empty selection
' DropUp event - Occurs when the drop-down portion of the control is hidden. Private Sub Excombobox1_DropUp(ByVal sender As System.Object) Handles Excombobox1.DropUp With Excombobox1 .Value = "" End With End Sub ' SelectionChanged event - Fired after a new item has been selected. Private Sub Excombobox1_SelectionChanged(ByVal sender As System.Object) Handles Excombobox1.SelectionChanged With Excombobox1 Debug.Print( "You selected: " ) Debug.Print( .Value ) End With End Sub With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .HeaderVisible = False .AutoSearch = True .AutoDropDown = True .IntegralHeight = True .Columns.Add("Default").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains With .Items .AddItem("This is a bit of text") .AddItem("This is a another text") .DefaultItem = .InsertItem(Nothing,Nothing,"") .set_ItemPosition(0,0) .set_SortableItem(0,False) End With .EndUpdate() End With |
472 |
I cannot seem to get autosearch=1 (contains) in the column object to search properly. It still only finds items that start with the typed character. I want to it look to see if the typed character(s) are contained in the item. I Can't seem to get this to work
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .HeaderVisible = False .AutoSearch = True .AutoDropDown = True .IntegralHeight = True .Columns.Add("Default").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains With .Items .AddItem("This is a bit of text") .AddItem("This is a another text") End With .EndUpdate() End With |
471 |
If the user selects an item from the list, how can I clear that selection and return the control to the unselected state with the PROMPT text
' DropUp event - Occurs when the drop-down portion of the control is hidden. Private Sub Excombobox1_DropUp(ByVal sender As System.Object) Handles Excombobox1.DropUp With Excombobox1 .set_EditText(0,"") End With End Sub ' SelectionChanged event - Fired after a new item has been selected. Private Sub Excombobox1_SelectionChanged(ByVal sender As System.Object) Handles Excombobox1.SelectionChanged With Excombobox1 Debug.Print( "You selected: " ) Debug.Print( .Value ) End With End Sub With Excombobox1 .BeginUpdate() .LabelHeight = 23 .IntegralHeight = True .AutoComplete = False .AutoSearch = False .AutoDropDown = True .Columns.Add("Default").Prompt = "<i><fgcolor=808080>type something</fgcolor></i>" With .Items .AddItem(0) .AddItem(1) .AddItem(2) End With .EndUpdate() End With |
470 |
How do I get notified once the user changes the Filter For field
' EditChange event - Fired when the user has taken an action that may have altered text in an edit control. Private Sub Excombobox1_EditChange(ByVal sender As System.Object,ByVal ColIndex As Integer) Handles Excombobox1.EditChange With Excombobox1 Debug.Print( "ColIndex: " ) Debug.Print( ColIndex ) Debug.Print( "Label: " ) Debug.Print( .get_EditText(0) ) Debug.Print( "FilterFor: " ) Debug.Print( .get_EditText(-1) ) End With End Sub With Excombobox1 .BeginUpdate() .FilterForVisible = True .FilterForBackColor = Color.FromArgb(240,240,240) .IntegralHeight = True .Columns.Add("Default") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .AddItem("Item 5") End With .EndUpdate() End With |
469 |
I am using the ScrollWidth/ScrollHeight property on 0 to hide the control's scroll bars, the question is that the drop down button is disappearing. What can be done so I can still show the drop down button
|
468 |
Does your control supports scrolling by touching the screen
Dim rs With Excombobox1 .BeginUpdate() .ColumnAutoResize = False rs = New ADODB.Recordset() With rs .Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\sample.mdb",3,3) End With .DataSource = rs .ScrollBySingleLine = True .AutoDrag = exontrol.EXCOMBOBOXLib.AutoDragEnum.exAutoDragScrollOnShortTouch Or exontrol.EXCOMBOBOXLib.AutoDragEnum.exAutoDragScroll .EndUpdate() End With |
467 |
How can I make bigger/enlarge the control's drop down button
With Excombobox1 .BeginUpdate() .LabelHeight = 40 .ScrollWidth = 40 .EndUpdate() End With |
466 |
How do I select a NULL/empty value
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .Columns.Add("Items") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .DefaultItem = .InsertItem(Nothing,Nothing,"") .set_ItemPosition(0,0) .set_SortableItem(0,False) End With .Value = "" .EndUpdate() End With |
465 |
How can I add a vertical padding
With Excombobox1 .BeginUpdate() .DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exAllLines With .Columns.Add("Padding") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellPaddingLeft,6) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellPaddingRight,6) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellPaddingTop,6) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellPaddingBottom,6) End With With .Items .AddItem("padding") .AddItem("padding") End With .EndUpdate() End With |
464 |
How can I add or change the padding (spaces) for captions in the control's header
With Excombobox1 .BeginUpdate() .Columns.Add("Padding-Left").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingLeft,18) With .Columns.Add("Padding-Right") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exHeaderPaddingRight,18) .HeaderAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment End With .EndUpdate() End With |
463 |
Is it possible to change the height for all items at once
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Columns.Add("Items") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(0,True) End With .EndUpdate() .DefaultItemHeight = 12 .Items.set_ItemHeight(0,12) End With |
462 |
How can I have a case-insensitive filter (exFilterDoCaseSensitive flag is not set)
With Excombobox1 .BeginUpdate() .MarkSearchColumn = False With .Columns With .Add("Car") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "MAZDA" End With With .Add("Equipment") .DisplayFilterButton = True .DisplayFilterPattern = False .CustomFilter = "Air Bag||*Air Bag*|||Air condition||*Air condition*|||ABS||*ABS*|||ESP||*ESP*" .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern .Filter = "AIR BAG" End With End With With .Items .set_CellCaption(.AddItem("Mazda"),1,"Air Bag") .set_CellCaption(.AddItem("Toyota"),1,"Air Bag,Air condition") .set_CellCaption(.AddItem("Ford"),1,"Air condition") .set_CellCaption(.AddItem("Nissan"),1,"Air Bag,ABS,ESP") .set_CellCaption(.AddItem("Mazda"),1,"Air Bag, ABS,ESP") .set_CellCaption(.AddItem("Mazda"),1,"ABS,ESP") End With .ApplyFilter() .EndUpdate() End With |
461 |
How can I have a case-sensitive filter
With Excombobox1 .BeginUpdate() .MarkSearchColumn = False With .Columns With .Add("Car") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilterDoCaseSensitive Or exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "Mazda" End With With .Add("Equipment") .DisplayFilterButton = True .DisplayFilterPattern = False .CustomFilter = "Air Bag||*Air Bag*|||Air condition||*Air condition*|||ABS||*ABS*|||ESP||*ESP*" .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilterDoCaseSensitive Or exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern .Filter = "Air Bag" End With End With With .Items .set_CellCaption(.AddItem("Mazda"),1,"Air Bag") .set_CellCaption(.AddItem("Toyota"),1,"Air Bag,Air condition") .set_CellCaption(.AddItem("Ford"),1,"Air condition") .set_CellCaption(.AddItem("Nissan"),1,"Air Bag,ABS,ESP") .set_CellCaption(.AddItem("Mazda"),1,"Air Bag, ABS,ESP") .set_CellCaption(.AddItem("Mazda"),1,"ABS,ESP") End With .ApplyFilter() .EndUpdate() End With |
460 |
Is it possible to filter the items as I type
' EditChange event - Fired when the user has taken an action that may have altered text in an edit control. Private Sub Excombobox1_EditChange(ByVal sender As System.Object,ByVal ColIndex As Integer) Handles Excombobox1.EditChange With Excombobox1 .Columns.Item(0).Filter = Excombobox1.get_EditText(0) .ApplyFilter() End With End Sub With Excombobox1 .BeginUpdate() .MarkSearchColumn = False .SingleEdit = True .AutoComplete = False .AutoDropDown = True .IntegralHeight = True With .Columns With .Add("Items") .Prompt = "<i><fgcolor=808080>Start Filter</fgcolor></i>" .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern End With End With With .Items .AddItem("A") .AddItem("B") .AddItem("C") .AddItem("AB") .AddItem("AC") .AddItem("BA") .AddItem("BC") .AddItem("CC") End With .EndUpdate() End With |
459 |
What is the equivalent to combo1.text=combo1.list(index) to select a row in the combo
|
458 |
What is the equivalent to combo1.text=combo1.list(index) to select a row in the combo
|
457 |
What is the equivalent to combo1.text=combo1.list(index) to select a row in the combo
|
456 |
What is the equivalent to combo1.text=combo1.list(index) to select a row in the combo
|
455 |
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
With Excombobox1 .BeginUpdate() .MarkSearchColumn = False With .ConditionalFormats.Add("1") .Bold = True .ForeColor = Color.FromArgb(255,0,0) .ApplyTo = &H1 End With .Columns.Add("C1") With .Columns.Add("C2") .HeaderBold = True .HTMLCaption = "<fgcolor=FF0000>C2" End With With .Items .set_CellCaption(.AddItem(10),1,11) .set_CellCaption(.AddItem(12),1,13) End With .EndUpdate() End With |
454 |
How can I add a horizontal scroll bar
With Excombobox1 .BeginUpdate() .ScrollBySingleLine = True .ColumnAutoResize = False .BackColorAlternate = Color.FromArgb(240,240,240) With .Columns.Add("Default") .Width = 512 .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False) End With With .Items .AddItem("Exontrol is devoted to create innovative user interface components for Windows applications, on COM or .NET platforms, since 19" & _ "99. ""eXontrol"" comes from e(s)pecial (c)ontrol, where sc makes the X. We are a vendor not a reseller, and this is the single s" & _ "ite where you can try or buy our products. If you are tired of looking for ""powerful"" components now it's time to show you rea" & _ "l components. No registration required, no nag screens, no limitations, unlimited evaluation time.") .AddItem("A combo box is a commonly-used GUI tool. It is a combination of a drop-down list or list box and a single-line textbox, allowin" & _ "g the user either to type a value directly into the control or choose from the list of existing options.") End With .EndUpdate() End With |
453 |
Does the control have the option to have a horizontal scroll to show entries which are longer than the display
With Excombobox1 .BeginUpdate() .ColumnAutoResize = False .Columns.Add("Default").Width = 512 With .Items .AddItem("Exontrol is devoted to create innovative user interface components for Windows applications, on COM or .NET platforms, since 19" & _ "99. ""eXontrol"" comes from e(s)pecial (c)ontrol, where sc makes the X. We are a vendor not a reseller, and this is the single s" & _ "ite where you can try or buy our products. If you are tired of looking for ""powerful"" components now it's time to show you rea" & _ "l components. No registration required, no nag screens, no limitations, unlimited evaluation time.") .AddItem("A combo box is a commonly-used GUI tool. It is a combination of a drop-down list or list box and a single-line textbox, allowin" & _ "g the user either to type a value directly into the control or choose from the list of existing options.") End With .EndUpdate() End With |
452 |
Is it possible to auto-numbering the children items but still keeps the position after filtering
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot With .Columns.Add("Items") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "Child 2" End With With .Columns.Add("Pos.1") .FormatColumn = "1 ropos ''" .Position = 0 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.2") .FormatColumn = "1 ropos ':'" .Position = 1 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.3") .FormatColumn = "1 ropos ':|A-Z'" .Position = 2 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.4") .FormatColumn = "1 ropos '|A-Z|'" .Position = 3 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.5") .FormatColumn = "'<font Tahoma;7>' + 1 ropos '-<b>||A-Z'" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .Position = 4 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.6") .FormatColumn = "'<b>'+ 1 ropos '</b>:<fgcolor=FF0000>|A-Z|'" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .Position = 5 .Width = 48 .AllowSizing = False End With With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") End With .ApplyFilter() .EndUpdate() End With |
451 |
How do I prevent scrolling the control's data after user does the sort
With Excombobox1 .EnsureOnSort = False .Columns.Add("Column") With .Items .AddItem("Item 3") .AddItem("Item 1") .AddItem("Item 2") End With .PutItems(.GetItems(0)) .PutItems(.GetItems(0)) .PutItems(.GetItems(0)) .Columns.Item(0).SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending End With |
450 |
Is it possible to auto-numbering the children items too
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Columns.Add("Items") With .Columns.Add("Pos.1") .FormatColumn = "1 rpos ''" .Position = 0 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.2") .FormatColumn = "1 rpos ':'" .Position = 1 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.3") .FormatColumn = "1 rpos ':|A-Z'" .Position = 2 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.4") .FormatColumn = "1 rpos '|A-Z|'" .Position = 3 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.5") .FormatColumn = "'<font Tahoma;7>' + 1 rpos '-<b>||A-Z'" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .Position = 4 .Width = 32 .AllowSizing = False End With With .Columns.Add("Pos.6") .FormatColumn = "'<b>'+ 1 rpos '</b>:<fgcolor=FF0000>|A-Z|'" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .Position = 5 .Width = 48 .AllowSizing = False End With With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") End With .EndUpdate() End With |
449 |
How can I show the child items with no identation
Dim h With Excombobox1 .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesOutside .Indent = 12 .HasLines = exontrol.EXCOMBOBOXLib.HierarchyLineEnum.exThinLine .Columns.Add("Default") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") End With End With |
448 |
Is there other ways of showing the hierarchy lines (exGroupLinesAtRoot)
Dim h With Excombobox1 .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot .Indent = 12 .Columns.Add("Default") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) End With End With |
447 |
Is there other ways of showing the hierarchy lines (exGroupLinesOutside)
Dim h With Excombobox1 .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesOutside .Indent = 12 .Columns.Add("Default") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") End With End With |
446 |
Is there other ways of showing the hierarchy lines (exGroupLinesInsideLeaf)
Dim h With Excombobox1 .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesInsideLeaf .Indent = 12 .Columns.Add("Default") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) End With End With |
445 |
Is there other ways of showing the hierarchy lines (exGroupLinesInside)
Dim h With Excombobox1 .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesInside .Indent = 12 .Columns.Add("Default") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) End With End With |
444 |
Is there other ways of showing the hierarchy lines (exGroupLines)
Dim h With Excombobox1 .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLines .Indent = 12 .Columns.Add("Default") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(.InsertItem(h,Nothing,"Child 2"),Nothing,"SubChild 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) End With End With |
443 |
Is it possible display numbers in the same format no matter of regional settings in the control panel
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(100000.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default positive)'") h = .AddItem(100000.27) .set_FormatCell(h,0,"(value format '2|.|3|,|1|1')") h = .AddItem(-100000.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default negative)'") h = .AddItem(-100000.27) .set_FormatCell(h,0,"(value format '2|.|3|,|1|1')") End With .EndUpdate() End With |
442 |
Is it possible to add a 0 for numbers less than 1 instead .7 to show 0.8
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(0.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'") h = .AddItem(0.27) .set_FormatCell(h,0,"(value format '|||||0') + ' <fgcolor=808080>(Display no leading zeros)'") End With .EndUpdate() End With |
441 |
How can I specify the format for negative numbers
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(-100000.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'") h = .AddItem(-100000.27) .set_FormatCell(h,0,"(value format '||||1') + ' <fgcolor=808080>(Negative sign, number; for example, -1.1)'") End With .EndUpdate() End With |
440 |
Is it possible to change the grouping character when display numbers
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(100000.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'") h = .AddItem(100000.27) .set_FormatCell(h,0,"(value format '|||-') + ' <fgcolor=808080>(grouping character is -)'") End With .EndUpdate() End With |
439 |
How can I display numbers with 2 digits in each group
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(100000.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'") h = .AddItem(100000.27) .set_FormatCell(h,0,"(value format '||2') + ' <fgcolor=808080>(grouping by 2 digits)'") End With .EndUpdate() End With |
438 |
How can I display my numbers using a different decimal separator
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(100.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'") h = .AddItem(100.27) .set_FormatCell(h,0,"(value format '|;') + ' <fgcolor=808080>(decimal separator is <b>;</b>)'") End With .EndUpdate() End With |
437 |
Is it possible to display the numbers using 3 (three) digits
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Def").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) With .Items h = .AddItem(100.27) .set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'") h = .AddItem(100.27) .set_FormatCell(h,0,"(value format '3') + ' <fgcolor=808080>(3 digits)'") h = .AddItem(100.27) .set_FormatCell(h,0,"(value format 2) + ' <fgcolor=808080>(2 digits)'") h = .AddItem(100.27) .set_FormatCell(h,0,"(value format 1) + ' <fgcolor=808080>(1 digit)'") End With .EndUpdate() End With |
436 |
Is it possible to format numbers
Dim h,h1 With Excombobox1 .BeginUpdate() .MarkSearchColumn = False With .Columns .Add("Name") With .Add("A") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric .AllowSizing = False .Width = 36 .FormatColumn = "len(value) ? value + ' +'" End With With .Add("B") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric .AllowSizing = False .Width = 36 .FormatColumn = "len(value) ? value + ' +'" End With With .Add("C") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric .AllowSizing = False .Width = 36 .FormatColumn = "len(value) ? value + ' ='" End With With .Add("A+B+C") .SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric .Width = 64 .ComputedField = "dbl(%1)+dbl(%2)+dbl(%3)" .FormatColumn = "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=00" & _ "00FF>+'+(value format '2|.|3|,' ): '0.00') )" .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) End With End With With .Items h = .AddItem("Root") .set_CellCaptionFormat(h,4,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exComputedField) h1 = .InsertItem(h,Nothing,"Child 1") .set_CellCaption(h1,1,7) .set_CellCaption(h1,2,3) .set_CellCaption(h1,3,1) h1 = .InsertItem(h,Nothing,"Child 2") .set_CellCaption(h1,1,-2) .set_CellCaption(h1,2,-2) .set_CellCaption(h1,3,-4) h1 = .InsertItem(h,Nothing,"Child 3") .set_CellCaption(h1,1,2) .set_CellCaption(h1,2,2) .set_CellCaption(h1,3,-4) .set_ExpandItem(h,True) End With .EndUpdate() End With |
435 |
Is it possible to limit the height of the item while resizing
' InsertItem event - Occurs after a new item has been inserted to Items collection. Private Sub Excombobox1_InsertItem(ByVal sender As System.Object,ByVal Item As Integer) Handles Excombobox1.InsertItem With Excombobox1 .Items.set_ItemMinHeight(Item,18) .Items.set_ItemMaxHeight(Item,72) End With End Sub With Excombobox1 .BeginUpdate() .ItemsAllowSizing = exontrol.EXCOMBOBOXLib.ItemsAllowSizingEnum.exResizeItem .ScrollBySingleLine = False .BackColorAlternate = Color.FromArgb(240,240,240) .Columns.Add("Names") With .Items .AddItem("Mantel") .AddItem("Mechanik") .AddItem("Motor") .AddItem("Murks") .AddItem("Märchen") .AddItem("Möhren") .AddItem("Mühle") End With .Columns.Item(0).SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending .EndUpdate() End With |
434 |
How can I simulate displaying groups
Dim h,h1 With Excombobox1 .HasLines = exontrol.EXCOMBOBOXLib.HierarchyLineEnum.exNoLine .ScrollBySingleLine = True With .Columns .Add("Name") .Add("A") .Add("B") .Add("C") End With With .Items h = .AddItem("Group 1") .set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment) .set_ItemDivider(h,0) .set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerBoth) .set_ItemHeight(h,24) .set_SortableItem(h,False) h1 = .InsertItem(h,Nothing,"Child 1") .set_CellCaption(h1,1,1) .set_CellCaption(h1,2,2) .set_CellCaption(h1,3,3) h1 = .InsertItem(h,Nothing,"Child 2") .set_CellCaption(h1,1,4) .set_CellCaption(h1,2,5) .set_CellCaption(h1,3,6) .set_ExpandItem(h,True) h = .AddItem("Group 2") .set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment) .set_ItemDivider(h,0) .set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerBoth) .set_ItemHeight(h,24) .set_SortableItem(h,False) h1 = .InsertItem(h,Nothing,"Child 1") .set_CellCaption(h1,1,1) .set_CellCaption(h1,2,2) .set_CellCaption(h1,3,3) h1 = .InsertItem(h,Nothing,"Child 2") .set_CellCaption(h1,1,4) .set_CellCaption(h1,2,5) .set_CellCaption(h1,3,6) .set_ExpandItem(h,True) End With End With |
433 |
How can I specify an item to be always the first item
Dim h With Excombobox1 .BeginUpdate() .TreeColumnIndex = -1 .Columns.Add("Numbers").SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric With .Items .AddItem(1) .AddItem(2) .AddItem(3) .AddItem(4) h = .AddItem("first") .set_ItemPosition(h,0) .set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment) .set_SortableItem(h,False) .SortChildren(0,0,False) End With .EndUpdate() End With |
432 |
How can I specify an item to be always the last item
Dim h With Excombobox1 .BeginUpdate() .TreeColumnIndex = -1 .Columns.Add("Numbers").SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric With .Items .AddItem(1) .AddItem(2) .AddItem(3) .AddItem(4) h = .AddItem("last") .set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment) .set_SortableItem(h,False) .SortChildren(0,0,True) End With .EndUpdate() End With |
431 |
Can I allow sorting only the child items
Dim h With Excombobox1 .BeginUpdate() .Columns.Add("Childs") With .Items h = .AddItem("Root 1") .set_SortableItem(h,False) .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .set_SortableItem(h,False) .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) End With .EndUpdate() End With |
430 |
Can I specify a terminal item so it will mark the end of childs
Dim h With Excombobox1 .BeginUpdate() .ScrollBySingleLine = True .Columns.Add("P1") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .InsertItem(h,"","") .set_ItemDivider(h,0) .set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter) .set_ItemHeight(h,2) .set_SelectableItem(h,False) .set_SortableItem(h,False) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .InsertItem(h,"","") .set_ItemDivider(h,0) .set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter) .set_ItemHeight(h,2) .set_SelectableItem(h,False) .set_SortableItem(h,False) End With .EndUpdate() End With |
429 |
Is it possible to specify an item being unsortable so its position won't be changed after sorting
Dim h With Excombobox1 .BeginUpdate() .TreeColumnIndex = -1 .Columns.Add("Numbers").SortType = exontrol.EXCOMBOBOXLib.SortTypeEnum.SortNumeric With .Items .AddItem(1) .AddItem(2) .AddItem(3) .AddItem(4) h = .AddItem("top 3") .set_ItemPosition(h,3) .set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment) .set_SortableItem(h,False) .SortChildren(0,0,False) End With .EndUpdate() End With |
428 |
Can I specify an item to be a separator
Dim h With Excombobox1 .BeginUpdate() .TreeColumnIndex = -1 .SortOnClick = exontrol.EXCOMBOBOXLib.SortOnClickEnum.exNoSort .Columns.Add("Numbers") With .Items .AddItem(1) .AddItem(2) h = .AddItem("separator") .set_SelectableItem(h,False) .set_ItemDivider(h,0) .set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter) .set_ItemDividerLine(h,exontrol.EXCOMBOBOXLib.DividerLineEnum.ThinLine) .set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment) .AddItem(3) .AddItem(4) End With .EndUpdate() End With |
427 |
How can I collapse all items
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Columns.Add("Items") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(0,False) End With .EndUpdate() End With |
426 |
How can I expand all items
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .Columns.Add("Items") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(0,True) End With .EndUpdate() End With |
425 |
Is it possible to specify the cell's value but still want to display some formatted text instead the value
Dim h With Excombobox1 .BeginUpdate() .MarkSearchColumn = False .Columns.Add("Value") .Columns.Add("FormatCell") With .Items h = .AddItem(1) .set_CellCaption(h,1,12) .set_FormatCell(h,1,"currency(value)") h = .AddItem(#1/1/2001#) .set_CellCaption(h,1,#1/1/2001#) .set_CellCaptionFormat(h,1,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML) .set_FormatCell(h,1,"longdate(value) replace '2001' with '<b>2001</b>'") End With .EndUpdate() End With |
424 |
How can I change the foreground color for a particular column
|
423 |
How can I change the background color for a particular column
|
422 |
How can I display the column using currency format and enlarge the font for certain values
|
421 |
How can I highlight only parts of the cells
Dim h With Excombobox1 With .Columns.Add("") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'" End With With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) End With End With |
420 |
How can I get the number of occurrences of a specified string in the cell
Dim h With Excombobox1 .Columns.Add("") With .Columns.Add("occurrences") .ComputedField = "lower(%0) count 'o'" .FormatColumn = "'contains ' + value + ' of \'o\' chars'" End With With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1 oooof the root") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"Child 3") .set_ExpandItem(h,True) End With End With |
419 |
How can I display dates in my format
|
418 |
How can I display dates in short format
|
417 |
How can I display dates in long format
|
416 |
How can I display only the right part of the cell
Dim h With Excombobox1 .Columns.Add("") With .Columns.Add("Right") .ComputedField = "%0 right 2" .FormatColumn = "'""' + value + '""'" End With With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .InsertItem(h,Nothing,"SChild 3") .set_ExpandItem(h,True) End With End With |
415 |
How can I display true or false instead 0 and -1
With Excombobox1 .Columns.Add("Boolean").FormatColumn = "value != 0 ? 'true' : 'false'" With .Items .AddItem(True) .AddItem(False) .AddItem(True) .AddItem(0) .AddItem(1) End With End With |
414 |
How can I display icons or images instead numbers
With Excombobox1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") With .Columns.Add("Icons") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1) .FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value" End With With .Items .AddItem(1) .AddItem(2) .AddItem(3) End With End With |
413 |
How can I display the column using currency
|
412 |
How can I filter programatically using more columns
With Excombobox1 .BeginUpdate() .MarkSearchColumn = False With .Columns .Add("Car") .Add("Equipment") End With With .Items .set_CellCaption(.AddItem("Mazda"),1,"Air Bag") .set_CellCaption(.AddItem("Toyota"),1,"Air Bag,Air condition") .set_CellCaption(.AddItem("Ford"),1,"Air condition") .set_CellCaption(.AddItem("Nissan"),1,"Air Bag,ABS,ESP") .set_CellCaption(.AddItem("Mazda"),1,"Air Bag, ABS,ESP") .set_CellCaption(.AddItem("Mazda"),1,"ABS,ESP") End With With .Columns.Item("Car") .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter .Filter = "Mazda" End With With .Columns.Item("Equipment") .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern .Filter = "*ABS*|*ESP*" End With .ApplyFilter() .EndUpdate() End With |
411 |
I need a combobox that supports selecting multiple items, preferably with checkboxes. I can't find an example of how to do this. Does your control support it
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Excombobox1_CellStateChanged(ByVal sender As System.Object,ByVal Cell As exontrol.EXCOMBOBOXLib.HCELL) Handles Excombobox1.CellStateChanged With Excombobox1 .LabelText = Cell Debug.Print( .Items.get_CellCaption(0,Cell) ) Debug.Print( .Items.get_CellState(0,Cell) ) End With End Sub With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .HeaderVisible = False .SingleEdit = True .SearchColumnIndex = -1 .AdjustSearchColumn = False .Columns.Add("Language").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) With .Items .AddItem("English") .AddItem("Hebrew") .AddItem("Spanish") End With .EndUpdate() End With |
410 |
How can I display a different caption in the label area, when I click the cell's check box
' CellStateChanged event - Fired after cell's state has been changed. Private Sub Excombobox1_CellStateChanged(ByVal sender As System.Object,ByVal Cell As exontrol.EXCOMBOBOXLib.HCELL) Handles Excombobox1.CellStateChanged With Excombobox1 .LabelText = Cell Debug.Print( .Items.get_CellCaption(0,Cell) ) Debug.Print( .Items.get_CellState(0,Cell) ) End With End Sub With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .HeaderVisible = False .SingleEdit = True .SearchColumnIndex = -1 .AdjustSearchColumn = False .Columns.Add("Language").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) With .Items .AddItem("English") .AddItem("Hebrew") .AddItem("Spanish") End With .LabelText = " <b>custom</b> text " .EndUpdate() End With |
409 |
How can I display a different caption in the label area
With Excombobox1 .BeginUpdate() .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList .IntegralHeight = True .HeaderVisible = False .SingleEdit = True .SearchColumnIndex = -1 .AdjustSearchColumn = False .Columns.Add("Language").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) With .Items .AddItem("English") .AddItem("Hebrew") .AddItem("Spanish") End With .LabelText = " <b>custom</b> text " .EndUpdate() End With |
408 |
How can I change the background appearance (ebn) for the filter field in the bottom part of the drop down portion
With Excombobox1 .BeginUpdate() .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .FilterForVisible = True .FilterForBackColor32 = &H1000000 .IntegralHeight = True .Columns.Add("Default") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .AddItem("Item 5") End With .EndUpdate() End With |
407 |
How can I change the background color for the filter field in the bottom part of the drop down portion
With Excombobox1 .BeginUpdate() .FilterForVisible = True .FilterForBackColor = Color.FromArgb(240,240,240) .IntegralHeight = True .Columns.Add("Default") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .AddItem("Item 5") End With .EndUpdate() End With |
406 |
How can I display a filter field in the bottom part of the drop down portion
With Excombobox1 .BeginUpdate() .FilterForVisible = True .IntegralHeight = True .Columns.Add("Default") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") .AddItem("Item 4") .AddItem("Item 5") End With .EndUpdate() End With |
405 |
Does your control support RightToLeft property for RTL languages or right to left
Dim h With Excombobox1 .BeginUpdate() .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot With .Columns.Add("P1") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) .PartialCheck = True End With With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) End With .RightToLeft = True .EndUpdate() End With |
404 |
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
With Excombobox1 .BeginUpdate() With .Columns .Add("C1") .Add("C2") .Add("C3") .Add("C4") .Add("C5") .Add("C6") .Add("C7") .Add("C8") End With .RightToLeft = True .EndUpdate() End With |
403 |
Can I display the cell's check box after the text
With Excombobox1 With .Columns.Add("Column") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check") End With With .Items .set_CellHasCheckBox(.AddItem("Caption 1"),0,True) .set_CellHasCheckBox(.AddItem("Caption 2"),0,True) End With End With |
402 |
Can I change the order of the parts in the cell, as checkbox after the text, and so on
Dim h With Excombobox1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .Columns.Add("Column").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture") With .Items h = .AddItem("Text") .set_CellImage(h,0,1) .set_CellHasCheckBox(h,0,True) End With End With |
401 |
Can I have an image displayed after the text. Can I get that effect without using HTML content
Dim h With Excombobox1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .Columns.Add("Column").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture") With .Items h = .AddItem("Text") .set_CellImage(h,0,1) End With End With |